Tabela Examination

Definicja tabeli Examination

Name

Examination

Code

Examination

Comment

 


Lista kolumn tabeli Examination

Name

Code

ExaminationID

ExaminationID

ServID

ServID

InfectionID

InfectionID

PerfServiceID

PerfServiceID

MaterialID

MaterialID

Active

Active

FullName

FullName

DateValue

DateValue

AccordanceWithAntibiogram

AccordanceWithAntibiogram

AntibioticTherapy

AntibioticTherapy

OtherMaterialType

OtherMaterialType

Antibiogram

Antibiogram

OtherExamination

OtherExamination

MaterialDescr

MaterialDescr


Kolumna ExaminationID tabeli Examination

Definicja kolumny ExaminationID tabeli Examination

Name

ExaminationID

Code

ExaminationID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ServID tabeli Examination

Definicja kolumny ServID tabeli Examination

Name

ServID

Code

ServID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InfectionID tabeli Examination

Definicja kolumny InfectionID tabeli Examination

Name

InfectionID

Code

InfectionID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PerfServiceID tabeli Examination

Definicja kolumny PerfServiceID tabeli Examination

Name

PerfServiceID

Code

PerfServiceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna MaterialID tabeli Examination

Definicja kolumny MaterialID tabeli Examination

Name

MaterialID

Code

MaterialID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Active tabeli Examination

Definicja kolumny Active tabeli Examination

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna FullName tabeli Examination

Definicja kolumny FullName tabeli Examination

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

PL: Pelna nazwa wiersza
EN: Record's full name
DE: Der voll Name des Rekord


Kolumna DateValue tabeli Examination

Definicja kolumny DateValue tabeli Examination

Name

DateValue

Code

DateValue

Data Type

DATE

Mandatory

No

Comment

 


Kolumna AccordanceWithAntibiogram tabeli Examination

Definicja kolumny AccordanceWithAntibiogram tabeli Examination

Name

AccordanceWithAntibiogram

Code

AccordanceWithAntibiogram

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna AntibioticTherapy tabeli Examination

Definicja kolumny AntibioticTherapy tabeli Examination

Name

AntibioticTherapy

Code

AntibioticTherapy

Data Type

CLOB

Mandatory

No

Comment

 


Kolumna OtherMaterialType tabeli Examination

Definicja kolumny OtherMaterialType tabeli Examination

Name

OtherMaterialType

Code

OtherMaterialType

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna Antibiogram tabeli Examination

Definicja kolumny Antibiogram tabeli Examination

Name

Antibiogram

Code

Antibiogram

Data Type

CLOB

Mandatory

No

Comment

 


Kolumna OtherExamination tabeli Examination

Definicja kolumny OtherExamination tabeli Examination

Name

OtherExamination

Code

OtherExamination

Data Type

CLOB

Mandatory

No

Comment

 


Kolumna MaterialDescr tabeli Examination

Definicja kolumny MaterialDescr tabeli Examination

Name

MaterialDescr

Code

MaterialDescr

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Lista kluczy tabeli Examination

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Examination

Definicja klucza Identifier_1 tabeli Examination

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment